Overview
Brought to you by YData
Dataset statistics
| Number of variables | 9 |
|---|---|
| Number of observations | 60398 |
| Missing cells | 15 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.1 MiB |
| Average record size in memory | 72.0 B |
Variable types
| Text | 2 |
|---|---|
| Numeric | 7 |
sls_due_dt is highly overall correlated with sls_order_dt and 1 other fields | High correlation |
sls_order_dt is highly overall correlated with sls_due_dt and 1 other fields | High correlation |
sls_price is highly overall correlated with sls_sales | High correlation |
sls_sales is highly overall correlated with sls_price | High correlation |
sls_ship_dt is highly overall correlated with sls_due_dt and 1 other fields | High correlation |
sls_order_dt is highly skewed (γ1 = -56.34108454) | Skewed |
sls_quantity is highly skewed (γ1 = 162.1480759) | Skewed |
Reproduction
| Analysis started | 2025-11-05 12:43:59.756930 |
|---|---|
| Analysis finished | 2025-11-05 12:44:04.754430 |
| Duration | 5 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
sls_ord_num
Text
| Distinct | 27659 |
|---|---|
| Distinct (%) | 45.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 9668 ? |
|---|---|
| Unique (%) | 16.0% |
Sample
| 1st row | SO43697 |
|---|---|
| 2nd row | SO43698 |
| 3rd row | SO43699 |
| 4th row | SO43700 |
| 5th row | SO43701 |
| Value | Count | Frequency (%) |
| so58845 | 8 | < 0.1% |
| so72656 | 8 | < 0.1% |
| so70714 | 8 | < 0.1% |
| so51555 | 7 | < 0.1% |
| so60233 | 7 | < 0.1% |
| so71961 | 7 | < 0.1% |
| so74869 | 7 | < 0.1% |
| so64542 | 7 | < 0.1% |
| so62984 | 7 | < 0.1% |
| so58572 | 7 | < 0.1% |
| Other values (27649) | 60325 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 60398 | |
| O | 60398 | |
| 6 | 47143 | |
| 5 | 44004 | |
| 7 | 35344 | |
| 4 | 30836 | |
| 2 | 25066 | |
| 3 | 24928 | |
| 1 | 23946 | 5.7% |
| 0 | 23824 | 5.6% |
| Other values (2) | 46899 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 301990 | |
| Uppercase Letter | 120796 | 28.6% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 47143 | |
| 5 | 44004 | |
| 7 | 35344 | |
| 4 | 30836 | |
| 2 | 25066 | |
| 3 | 24928 | |
| 1 | 23946 | |
| 0 | 23824 | |
| 8 | 23580 | |
| 9 | 23319 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 60398 | |
| O | 60398 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 301990 | |
| Latin | 120796 | 28.6% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 47143 | |
| 5 | 44004 | |
| 7 | 35344 | |
| 4 | 30836 | |
| 2 | 25066 | |
| 3 | 24928 | |
| 1 | 23946 | |
| 0 | 23824 | |
| 8 | 23580 | |
| 9 | 23319 |
Latin
| Value | Count | Frequency (%) |
| S | 60398 | |
| O | 60398 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 422786 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 60398 | |
| O | 60398 | |
| 6 | 47143 | |
| 5 | 44004 | |
| 7 | 35344 | |
| 4 | 30836 | |
| 2 | 25066 | |
| 3 | 24928 | |
| 1 | 23946 | 5.7% |
| 0 | 23824 | 5.6% |
| Other values (2) | 46899 |
sls_prd_key
Text
| Distinct | 130 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 8.1647074 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BK-R93R-62 |
|---|---|
| 2nd row | BK-M82S-44 |
| 3rd row | BK-M82S-44 |
| 4th row | BK-R50B-62 |
| 5th row | BK-M82S-44 |
| Value | Count | Frequency (%) |
| wb-h098 | 4244 | 7.0% |
| pk-7098 | 3191 | 5.3% |
| tt-m928 | 3095 | 5.1% |
| tt-r982 | 2376 | 3.9% |
| hl-u509-r | 2230 | 3.7% |
| ca-1098 | 2190 | 3.6% |
| hl-u509-b | 2125 | 3.5% |
| fe-6654 | 2121 | 3.5% |
| hl-u509 | 2085 | 3.5% |
| bc-m005 | 2025 | 3.4% |
| Other values (120) | 34716 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 87602 | |
| 9 | 38742 | 7.9% |
| 0 | 38558 | 7.8% |
| 8 | 32143 | 6.5% |
| B | 30620 | 6.2% |
| T | 25939 | 5.3% |
| 2 | 24470 | 5.0% |
| R | 20829 | 4.2% |
| K | 18396 | 3.7% |
| 4 | 17737 | 3.6% |
| Other values (23) | 158096 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 210589 | |
| Uppercase Letter | 194941 | |
| Dash Punctuation | 87602 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 30620 | |
| T | 25939 | |
| R | 20829 | |
| K | 18396 | |
| M | 15706 | |
| H | 14194 | |
| L | 12611 | 6.5% |
| S | 7918 | 4.1% |
| U | 7723 | 4.0% |
| C | 7397 | 3.8% |
| Other values (12) | 33608 |
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 38742 | |
| 0 | 38558 | |
| 8 | 32143 | |
| 2 | 24470 | |
| 4 | 17737 | |
| 5 | 17011 | |
| 6 | 15299 | 7.3% |
| 1 | 10973 | 5.2% |
| 7 | 7905 | 3.8% |
| 3 | 7751 | 3.7% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 87602 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 298191 | |
| Latin | 194941 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 30620 | |
| T | 25939 | |
| R | 20829 | |
| K | 18396 | |
| M | 15706 | |
| H | 14194 | |
| L | 12611 | 6.5% |
| S | 7918 | 4.1% |
| U | 7723 | 4.0% |
| C | 7397 | 3.8% |
| Other values (12) | 33608 |
Common
| Value | Count | Frequency (%) |
| - | 87602 | |
| 9 | 38742 | |
| 0 | 38558 | |
| 8 | 32143 | 10.8% |
| 2 | 24470 | 8.2% |
| 4 | 17737 | 5.9% |
| 5 | 17011 | 5.7% |
| 6 | 15299 | 5.1% |
| 1 | 10973 | 3.7% |
| 7 | 7905 | 2.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 493132 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 87602 | |
| 9 | 38742 | 7.9% |
| 0 | 38558 | 7.8% |
| 8 | 32143 | 6.5% |
| B | 30620 | 6.2% |
| T | 25939 | 5.3% |
| 2 | 24470 | 5.0% |
| R | 20829 | 4.2% |
| K | 18396 | 3.7% |
| 4 | 17737 | 3.6% |
| Other values (23) | 158096 |
sls_cust_id
Real number (ℝ)
| Distinct | 18484 |
|---|---|
| Distinct (%) | 30.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18841.685 |
| Minimum | 11000 |
|---|---|
| Maximum | 29483 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 11000 |
|---|---|
| 5-th percentile | 11414 |
| Q1 | 14003 |
| median | 18143 |
| Q3 | 23429.75 |
| 95-th percentile | 28108.15 |
| Maximum | 29483 |
| Range | 18483 |
| Interquartile range (IQR) | 9426.75 |
Descriptive statistics
| Standard deviation | 5432.4304 |
|---|---|
| Coefficient of variation (CV) | 0.28831977 |
| Kurtosis | -1.1617483 |
| Mean | 18841.685 |
| Median Absolute Deviation (MAD) | 4594.5 |
| Skewness | 0.28365312 |
| Sum | 1.1380001 × 109 |
| Variance | 29511300 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 11185 | 68 | 0.1% |
| 11300 | 67 | 0.1% |
| 11277 | 65 | 0.1% |
| 11262 | 63 | 0.1% |
| 11287 | 62 | 0.1% |
| 11176 | 60 | 0.1% |
| 11091 | 59 | 0.1% |
| 11331 | 58 | 0.1% |
| 11566 | 58 | 0.1% |
| 11330 | 57 | 0.1% |
| Other values (18474) | 59781 |
| Value | Count | Frequency (%) |
| 11000 | 8 | |
| 11001 | 11 | |
| 11002 | 4 | < 0.1% |
| 11003 | 9 | |
| 11004 | 6 | |
| 11005 | 6 | |
| 11006 | 5 | |
| 11007 | 8 | |
| 11008 | 7 | |
| 11009 | 5 |
| Value | Count | Frequency (%) |
| 29483 | 1 | < 0.1% |
| 29482 | 1 | < 0.1% |
| 29481 | 1 | < 0.1% |
| 29480 | 5 | |
| 29479 | 1 | < 0.1% |
| 29478 | 3 | |
| 29477 | 3 | |
| 29476 | 1 | < 0.1% |
| 29475 | 1 | < 0.1% |
| 29474 | 1 | < 0.1% |
sls_order_dt
Real number (ℝ)
High correlation Skewed
| Distinct | 1127 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20123403 |
| Minimum | 0 |
|---|---|
| Maximum | 20140128 |
| Zeros | 17 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 20120409 |
| Q1 | 20130402 |
| median | 20130714 |
| Q3 | 20131018 |
| 95-th percentile | 20131224 |
| Maximum | 20140128 |
| Range | 20140128 |
| Interquartile range (IQR) | 616 |
Descriptive statistics
| Standard deviation | 356972.28 |
|---|---|
| Coefficient of variation (CV) | 0.017739161 |
| Kurtosis | 3172.9843 |
| Mean | 20123403 |
| Median Absolute Deviation (MAD) | 308 |
| Skewness | -56.341085 |
| Sum | 1.2154133 × 1012 |
| Variance | 1.2742921 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20131212 | 263 | 0.4% |
| 20131001 | 246 | 0.4% |
| 20130605 | 241 | 0.4% |
| 20131209 | 238 | 0.4% |
| 20130819 | 237 | 0.4% |
| 20131205 | 227 | 0.4% |
| 20131215 | 222 | 0.4% |
| 20131226 | 220 | 0.4% |
| 20131029 | 220 | 0.4% |
| 20131219 | 219 | 0.4% |
| Other values (1117) | 58065 |
| Value | Count | Frequency (%) |
| 0 | 17 | |
| 5489 | 1 | < 0.1% |
| 32154 | 1 | < 0.1% |
| 20101229 | 5 | < 0.1% |
| 20101230 | 4 | < 0.1% |
| 20101231 | 5 | < 0.1% |
| 20110101 | 2 | < 0.1% |
| 20110102 | 5 | < 0.1% |
| 20110103 | 4 | < 0.1% |
| 20110104 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 20140128 | 96 | |
| 20140127 | 61 | |
| 20140126 | 68 | |
| 20140125 | 82 | |
| 20140124 | 65 | |
| 20140123 | 75 | |
| 20140122 | 57 | |
| 20140121 | 82 | |
| 20140120 | 69 | |
| 20140119 | 74 |
sls_ship_dt
Real number (ℝ)
High correlation
| Distinct | 1124 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20129938 |
| Minimum | 20110105 |
|---|---|
| Maximum | 20140204 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 20110105 |
|---|---|
| 5-th percentile | 20120418 |
| Q1 | 20130410 |
| median | 20130721 |
| Q3 | 20131025 |
| 95-th percentile | 20131231 |
| Maximum | 20140204 |
| Range | 30099 |
| Interquartile range (IQR) | 615 |
Descriptive statistics
| Standard deviation | 4851.0607 |
|---|---|
| Coefficient of variation (CV) | 0.00024098736 |
| Kurtosis | 7.5490007 |
| Mean | 20129938 |
| Median Absolute Deviation (MAD) | 308 |
| Skewness | -2.1619201 |
| Sum | 1.215808 × 1012 |
| Variance | 23532790 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20131219 | 263 | 0.4% |
| 20131008 | 246 | 0.4% |
| 20130612 | 241 | 0.4% |
| 20131216 | 238 | 0.4% |
| 20130826 | 237 | 0.4% |
| 20131212 | 227 | 0.4% |
| 20131222 | 222 | 0.4% |
| 20131105 | 220 | 0.4% |
| 20140102 | 220 | 0.4% |
| 20131226 | 219 | 0.4% |
| Other values (1114) | 58065 |
| Value | Count | Frequency (%) |
| 20110105 | 5 | |
| 20110106 | 4 | |
| 20110107 | 5 | |
| 20110108 | 2 | < 0.1% |
| 20110109 | 5 | |
| 20110110 | 4 | |
| 20110111 | 3 | |
| 20110112 | 3 | |
| 20110113 | 6 | |
| 20110114 | 3 |
| Value | Count | Frequency (%) |
| 20140204 | 96 | |
| 20140203 | 61 | |
| 20140202 | 68 | |
| 20140201 | 82 | |
| 20140131 | 65 | |
| 20140130 | 75 | |
| 20140129 | 57 | |
| 20140128 | 82 | |
| 20140127 | 69 | |
| 20140126 | 74 |
sls_due_dt
Real number (ℝ)
High correlation
| Distinct | 1124 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20130104 |
| Minimum | 20110110 |
|---|---|
| Maximum | 20140209 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 20110110 |
|---|---|
| 5-th percentile | 20120423 |
| Q1 | 20130415 |
| median | 20130726 |
| Q3 | 20131030 |
| 95-th percentile | 20140105 |
| Maximum | 20140209 |
| Range | 30099 |
| Interquartile range (IQR) | 615 |
Descriptive statistics
| Standard deviation | 4985.4532 |
|---|---|
| Coefficient of variation (CV) | 0.00024766157 |
| Kurtosis | 6.8220444 |
| Mean | 20130104 |
| Median Absolute Deviation (MAD) | 310 |
| Skewness | -1.9180773 |
| Sum | 1.215818 × 1012 |
| Variance | 24854744 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20131224 | 263 | 0.4% |
| 20131013 | 246 | 0.4% |
| 20130617 | 241 | 0.4% |
| 20131221 | 238 | 0.4% |
| 20130831 | 237 | 0.4% |
| 20131217 | 227 | 0.4% |
| 20131227 | 222 | 0.4% |
| 20131110 | 220 | 0.4% |
| 20140107 | 220 | 0.4% |
| 20131231 | 219 | 0.4% |
| Other values (1114) | 58065 |
| Value | Count | Frequency (%) |
| 20110110 | 5 | |
| 20110111 | 4 | |
| 20110112 | 5 | |
| 20110113 | 2 | < 0.1% |
| 20110114 | 5 | |
| 20110115 | 4 | |
| 20110116 | 3 | |
| 20110117 | 3 | |
| 20110118 | 6 | |
| 20110119 | 3 |
| Value | Count | Frequency (%) |
| 20140209 | 96 | |
| 20140208 | 61 | |
| 20140207 | 68 | |
| 20140206 | 82 | |
| 20140205 | 65 | |
| 20140204 | 75 | |
| 20140203 | 57 | |
| 20140202 | 82 | |
| 20140201 | 69 | |
| 20140131 | 74 |
sls_sales
Real number (ℝ)
High correlation
| Distinct | 48 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 8 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 486.09872 |
| Minimum | -54 |
|---|---|
| Maximum | 3578 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 3 |
| Negative (%) | < 0.1% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | -54 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 30 |
| Q3 | 540 |
| 95-th percentile | 2443 |
| Maximum | 3578 |
| Range | 3632 |
| Interquartile range (IQR) | 532 |
Descriptive statistics
| Standard deviation | 928.50087 |
|---|---|
| Coefficient of variation (CV) | 1.9101076 |
| Kurtosis | 2.5126588 |
| Mean | 486.09872 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | 1.9273089 |
| Sum | 29355502 |
| Variance | 862113.86 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=48)
| Value | Count | Frequency (%) |
| 5 | 8825 | 14.6% |
| 35 | 7832 | 13.0% |
| 9 | 4467 | 7.4% |
| 2 | 3190 | 5.3% |
| 4 | 2375 | 3.9% |
| 22 | 2120 | 3.5% |
| 10 | 2023 | 3.3% |
| 25 | 1789 | 3.0% |
| 50 | 1735 | 2.9% |
| 540 | 1695 | 2.8% |
| Other values (38) | 24339 |
| Value | Count | Frequency (%) |
| -54 | 1 | < 0.1% |
| -35 | 1 | < 0.1% |
| -18 | 1 | < 0.1% |
| 0 | 2 | < 0.1% |
| 2 | 3190 | 5.3% |
| 4 | 2375 | 3.9% |
| 5 | 8825 | |
| 8 | 907 | 1.5% |
| 9 | 4467 | |
| 10 | 2023 | 3.3% |
| Value | Count | Frequency (%) |
| 3578 | 1551 | |
| 3400 | 185 | 0.3% |
| 3375 | 211 | 0.3% |
| 2443 | 1145 | |
| 2384 | 1255 | |
| 2320 | 1215 | |
| 2295 | 1262 | |
| 2182 | 758 | |
| 2071 | 521 | 0.9% |
| 2049 | 554 | 0.9% |
sls_quantity
Real number (ℝ)
Skewed
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0004139 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.044011487 |
|---|---|
| Coefficient of variation (CV) | 0.043993277 |
| Kurtosis | 30535.36 |
| Mean | 1.0004139 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 162.14808 |
| Sum | 60423 |
| Variance | 0.001937011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 1 | 60387 | |
| 2 | 7 | < 0.1% |
| 5 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 60387 | |
| 2 | 7 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 2 | 7 | < 0.1% |
| 1 | 60387 |
sls_price
Real number (ℝ)
High correlation
| Distinct | 46 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 7 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 486.00813 |
| Minimum | -1701 |
|---|---|
| Maximum | 3578 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 5 |
| Negative (%) | < 0.1% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | -1701 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 30 |
| Q3 | 540 |
| 95-th percentile | 2443 |
| Maximum | 3578 |
| Range | 5279 |
| Interquartile range (IQR) | 532 |
Descriptive statistics
| Standard deviation | 928.53838 |
|---|---|
| Coefficient of variation (CV) | 1.9105408 |
| Kurtosis | 2.5129464 |
| Mean | 486.00813 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | 1.9270386 |
| Sum | 29350517 |
| Variance | 862183.52 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=46)
| Value | Count | Frequency (%) |
| 5 | 8825 | 14.6% |
| 35 | 7834 | 13.0% |
| 9 | 4469 | 7.4% |
| 2 | 3191 | 5.3% |
| 4 | 2376 | 3.9% |
| 22 | 2120 | 3.5% |
| 10 | 2024 | 3.4% |
| 25 | 1788 | 3.0% |
| 50 | 1736 | 2.9% |
| 540 | 1695 | 2.8% |
| Other values (36) | 24333 |
| Value | Count | Frequency (%) |
| -1701 | 1 | < 0.1% |
| -769 | 1 | < 0.1% |
| -30 | 1 | < 0.1% |
| -22 | 1 | < 0.1% |
| -21 | 1 | < 0.1% |
| 2 | 3191 | 5.3% |
| 4 | 2376 | 3.9% |
| 5 | 8825 | |
| 8 | 907 | 1.5% |
| 9 | 4469 |
| Value | Count | Frequency (%) |
| 3578 | 1551 | |
| 3400 | 185 | 0.3% |
| 3375 | 211 | 0.3% |
| 2443 | 1145 | |
| 2384 | 1255 | |
| 2320 | 1215 | |
| 2295 | 1262 | |
| 2182 | 758 | |
| 2071 | 521 | 0.9% |
| 2049 | 554 | 0.9% |
Interactions
Correlations
| sls_cust_id | sls_due_dt | sls_order_dt | sls_price | sls_quantity | sls_sales | sls_ship_dt | |
|---|---|---|---|---|---|---|---|
| sls_cust_id | 1.000 | 0.054 | 0.054 | -0.025 | -0.003 | -0.026 | 0.054 |
| sls_due_dt | 0.054 | 1.000 | 0.999 | -0.219 | -0.006 | -0.220 | 1.000 |
| sls_order_dt | 0.054 | 0.999 | 1.000 | -0.219 | -0.006 | -0.219 | 0.999 |
| sls_price | -0.025 | -0.219 | -0.219 | 1.000 | 0.001 | 1.000 | -0.219 |
| sls_quantity | -0.003 | -0.006 | -0.006 | 0.001 | 1.000 | 0.002 | -0.006 |
| sls_sales | -0.026 | -0.220 | -0.219 | 1.000 | 0.002 | 1.000 | -0.220 |
| sls_ship_dt | 0.054 | 1.000 | 0.999 | -0.219 | -0.006 | -0.220 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| sls_ord_num | sls_prd_key | sls_cust_id | sls_order_dt | sls_ship_dt | sls_due_dt | sls_sales | sls_quantity | sls_price | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | SO43697 | BK-R93R-62 | 21768 | 20101229 | 20110105 | 20110110 | 3578.0 | 1 | 3578.0 |
| 1 | SO43698 | BK-M82S-44 | 28389 | 20101229 | 20110105 | 20110110 | 3400.0 | 1 | 3400.0 |
| 2 | SO43699 | BK-M82S-44 | 25863 | 20101229 | 20110105 | 20110110 | 3400.0 | 1 | 3400.0 |
| 3 | SO43700 | BK-R50B-62 | 14501 | 20101229 | 20110105 | 20110110 | 699.0 | 1 | 699.0 |
| 4 | SO43701 | BK-M82S-44 | 11003 | 20101229 | 20110105 | 20110110 | 3400.0 | 1 | 3400.0 |
| 5 | SO43702 | BK-R93R-44 | 27645 | 20101230 | 20110106 | 20110111 | 3578.0 | 1 | 3578.0 |
| 6 | SO43703 | BK-R93R-62 | 16624 | 20101230 | 20110106 | 20110111 | 3578.0 | 1 | 3578.0 |
| 7 | SO43704 | BK-M82B-48 | 11005 | 20101230 | 20110106 | 20110111 | 3375.0 | 1 | 3375.0 |
| 8 | SO43705 | BK-M82S-38 | 11011 | 20101230 | 20110106 | 20110111 | 3400.0 | 1 | 3400.0 |
| 9 | SO43706 | BK-R93R-48 | 27621 | 20101231 | 20110107 | 20110112 | 3578.0 | 1 | 3578.0 |
| sls_ord_num | sls_prd_key | sls_cust_id | sls_order_dt | sls_ship_dt | sls_due_dt | sls_sales | sls_quantity | sls_price | |
|---|---|---|---|---|---|---|---|---|---|
| 60388 | SO75120 | SJ-0194-X | 18749 | 20140128 | 20140204 | 20140209 | 54.0 | 1 | 54.0 |
| 60389 | SO75120 | CA-1098 | 18749 | 20140128 | 20140204 | 20140209 | 9.0 | 1 | 9.0 |
| 60390 | SO75121 | TT-M928 | 15251 | 20140128 | 20140204 | 20140209 | 5.0 | 1 | 5.0 |
| 60391 | SO75121 | TI-M823 | 15251 | 20140128 | 20140204 | 20140209 | 35.0 | 1 | 35.0 |
| 60392 | SO75121 | HL-U509-R | 15251 | 20140128 | 20140204 | 20140209 | 35.0 | 1 | 35.0 |
| 60393 | SO75122 | FE-6654 | 15868 | 20140128 | 20140204 | 20140209 | 22.0 | 1 | 22.0 |
| 60394 | SO75122 | CA-1098 | 15868 | 20140128 | 20140204 | 20140209 | 9.0 | 1 | 9.0 |
| 60395 | SO75123 | FE-6654 | 18759 | 20140128 | 20140204 | 20140209 | 22.0 | 1 | 22.0 |
| 60396 | SO75123 | ST-1401 | 18759 | 20140128 | 20140204 | 20140209 | 159.0 | 1 | 159.0 |
| 60397 | SO75123 | CA-1098 | 18759 | 20140128 | 20140204 | 20140209 | 9.0 | 1 | 9.0 |